Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `ls_ans

  • Ruif
  • Ruif's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 weeks 1 day ago #259175 by Ruif
Please help us help you and fill where relevant:
Your LimeSurvey version: 6.5.1+240320 after updating from 6.3.9+231211
Own server or LimeSurvey hosting: Own server
Survey theme/template:Bootstrap Vanilla
MHP_extends_vanilla
==================
After a manual update from 6.3.9 to 6.5.1, a database update is requested. This results in The following error(dutch translation):
Het updaten is mislukt. Foutgegevens:

CDbCommand faalde tijdens het uitvoeren van volgend SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `ls_answers_idx`; check that it exists

Bestand Update_618.php, regel 14.


Any suggestions?

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 weeks 4 days ago #259399 by DenisChenu
1. report the issue
2. Comment this action in Update_618 OR add this index manually.

What is your DATABASE version ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: Ruif

Please Log in to join the conversation.

  • Ruif
  • Ruif's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 weeks 2 days ago #259551 by Ruif
Commenting the line in update_618 did the trickk

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose